Dataset info
| Number of variables | 41 |
|---|---|
| Number of observations | 59400 |
| Missing cells | 46094 (1.9%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 21.5 MiB |
| Average record size in memory | 380.1 B |
Variables types
| Numeric | 10 |
|---|---|
| Categorical | 27 |
| Boolean | 2 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 2 |
| Unsupported | 0 |
Warnings
amount_tsh is highly skewed (γ1 = 57.80779995) | Skewed |
amount_tsh has 41639 (70.1%) zeros | Zeros |
construction_year has 20709 (34.9%) zeros | Zeros |
date_recorded only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
date_recorded has a high cardinality: 356 distinct values | Warning |
funder has a high cardinality: 1898 distinct values | Warning |
funder has 3635 (6.1%) missing values | Missing |
gps_height has 20438 (34.4%) zeros | Zeros |
installer has a high cardinality: 2146 distinct values | Warning |
installer has 3655 (6.2%) missing values | Missing |
lga has a high cardinality: 125 distinct values | Warning |
longitude has 1812 (3.1%) zeros | Zeros |
num_private is highly skewed (γ1 = 91.93374999) | Skewed |
num_private has 58643 (98.7%) zeros | Zeros |
permit has 3056 (5.1%) missing values | Missing |
population has 21381 (36.0%) zeros | Zeros |
public_meeting has 3334 (5.6%) missing values | Missing |
quantity_group is a recoding of quantity | Rejected |
recorded_by has constant value "GeoData Consultants Ltd" | Rejected |
scheme_management has 3877 (6.5%) missing values | Missing |
scheme_name has a high cardinality: 2697 distinct values | Warning |
scheme_name has 28166 (47.4%) missing values | Missing |
subvillage has a high cardinality: 19288 distinct values | Warning |
ward has a high cardinality: 2092 distinct values | Warning |
wpt_name has a high cardinality: 37400 distinct values | Warning |
amount_tsh
Numeric
| Distinct count | 98 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 317.6503847 |
|---|---|
| Minimum | 0 |
| Maximum | 350000 |
| Zeros (%) | 70.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 20 |
| 95-th percentile | 1200 |
| Maximum | 350000 |
| Range | 350000 |
| Interquartile range | 20 |
Descriptive statistics
| Standard deviation | 2997.574558 |
|---|---|
| Coef of variation | 9.436709989 |
| Kurtosis | 4903.543102 |
| Mean | 317.6503847 |
| MAD | 522.1244629 |
| Skewness | 57.80779995 |
| Sum | 18868432.85 |
| Variance | 8985453.232 |
| Memory size | 928.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.000e+00 1.000e-01 3.500e+00 6.500e+00 8.000e+00 ... 2.250e+04 5.500e+04 1.085e+05 1.185e+05 3.500e+05], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 41639 | 70.1% | |
| 500 | 3102 | 5.2% | |
| 50 | 2472 | 4.2% | |
| 1000 | 1488 | 2.5% | |
| 20 | 1463 | 2.5% | |
| 200 | 1220 | 2.1% | |
| 100 | 816 | 1.4% | |
| 10 | 806 | 1.4% | |
| 30 | 743 | 1.3% | |
| 2000 | 704 | 1.2% | |
| Other values (88) | 4947 | 8.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 41639 | 70.1% | |
| 0.2 | 3 | < 0.1% | |
| 0.25 | 1 | < 0.1% | |
| 1 | 3 | < 0.1% | |
| 2 | 13 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 350000 | 1 | < 0.1% | |
| 250000 | 1 | < 0.1% | |
| 200000 | 1 | < 0.1% | |
| 170000 | 1 | < 0.1% | |
| 138000 | 1 | < 0.1% |
basin
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Lake Victoria | |
|---|---|
| Pangani | |
| Rufiji | |
| Other values (6) |
| Value | Count | Frequency (%) | |
| Lake Victoria | 10248 | 17.3% | |
| Pangani | 8940 | 15.1% | |
| Rufiji | 7976 | 13.4% | |
| Internal | 7785 | 13.1% | |
| Lake Tanganyika | 6432 | 10.8% | |
| Wami / Ruvu | 5987 | 10.1% | |
| Lake Nyasa | 5085 | 8.6% | |
| Ruvuma / Southern Coast | 4493 | 7.6% | |
| Lake Rukwa | 2454 | 4.1% |
| Max length | 23 |
|---|---|
| Mean length | 10.8923569 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
construction_year
Numeric
| Distinct count | 55 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1300.652475 |
|---|---|
| Minimum | 0 |
| Maximum | 2013 |
| Zeros (%) | 34.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1986 |
| Q3 | 2004 |
| 95-th percentile | 2010 |
| Maximum | 2013 |
| Range | 2013 |
| Interquartile range | 2004 |
Descriptive statistics
| Standard deviation | 951.6205473 |
|---|---|
| Coef of variation | 0.7316485885 |
| Kurtosis | -1.596432369 |
| Mean | 1300.652475 |
| MAD | 906.9094983 |
| Skewness | -0.6349277866 |
| Sum | 77258757 |
| Variance | 905581.6661 |
| Memory size | 928.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 980. 1960.5 1962.5 1963.5 ... 2007.5 2010.5 2011.5 2012.5 2013. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 20709 | 34.9% | |
| 2010 | 2645 | 4.5% | |
| 2008 | 2613 | 4.4% | |
| 2009 | 2533 | 4.3% | |
| 2000 | 2091 | 3.5% | |
| 2007 | 1587 | 2.7% | |
| 2006 | 1471 | 2.5% | |
| 2003 | 1286 | 2.2% | |
| 2011 | 1256 | 2.1% | |
| 2004 | 1123 | 1.9% | |
| Other values (45) | 22086 | 37.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 20709 | 34.9% | |
| 1960 | 102 | 0.2% | |
| 1961 | 21 | < 0.1% | |
| 1962 | 30 | 0.1% | |
| 1963 | 85 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2013 | 176 | 0.3% | |
| 2012 | 1084 | 1.8% | |
| 2011 | 1256 | 2.1% | |
| 2010 | 2645 | 4.5% | |
| 2009 | 2533 | 4.3% |
date_recorded
Categorical
| Distinct count | 356 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2011-03-15 | 572 |
|---|---|
| 2011-03-17 | 558 |
| 2013-02-03 | 546 |
| Other values (353) |
| Value | Count | Frequency (%) | |
| 2011-03-15 | 572 | 1.0% | |
| 2011-03-17 | 558 | 0.9% | |
| 2013-02-03 | 546 | 0.9% | |
| 2011-03-14 | 520 | 0.9% | |
| 2011-03-16 | 513 | 0.9% | |
| 2011-03-18 | 497 | 0.8% | |
| 2011-03-19 | 466 | 0.8% | |
| 2013-02-04 | 464 | 0.8% | |
| 2013-01-29 | 459 | 0.8% | |
| 2011-03-04 | 458 | 0.8% | |
| Other values (346) | 54347 | 91.5% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
district_code
Numeric
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.629747475 |
|---|---|
| Minimum | 0 |
| Maximum | 80 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 5 |
| 95-th percentile | 30 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 9.633648629 |
|---|---|
| Coef of variation | 1.711204396 |
| Kurtosis | 16.21428363 |
| Mean | 5.629747475 |
| MAD | 4.743533803 |
| Skewness | 3.962045299 |
| Sum | 334407 |
| Variance | 92.80718592 |
| Memory size | 928.1 KiB |
Histogram with fixed size bins (bins=20)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 48. 56.5 61. 65. 80. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1 | 12203 | 20.5% | |
| 2 | 11173 | 18.8% | |
| 3 | 9998 | 16.8% | |
| 4 | 8999 | 15.1% | |
| 5 | 4356 | 7.3% | |
| 6 | 4074 | 6.9% | |
| 7 | 3343 | 5.6% | |
| 8 | 1043 | 1.8% | |
| 30 | 995 | 1.7% | |
| 33 | 874 | 1.5% | |
| Other values (10) | 2342 | 3.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 23 | < 0.1% | |
| 1 | 12203 | 20.5% | |
| 2 | 11173 | 18.8% | |
| 3 | 9998 | 16.8% | |
| 4 | 8999 | 15.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 80 | 12 | < 0.1% | |
| 67 | 6 | < 0.1% | |
| 63 | 195 | 0.3% | |
| 62 | 109 | 0.2% | |
| 60 | 63 | 0.1% |
extraction_type
Categorical
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| gravity | |
|---|---|
| nira/tanira | |
| other | |
| Other values (15) |
| Value | Count | Frequency (%) | |
| gravity | 26780 | 45.1% | |
| nira/tanira | 8154 | 13.7% | |
| other | 6430 | 10.8% | |
| submersible | 4764 | 8.0% | |
| swn 80 | 3670 | 6.2% | |
| mono | 2865 | 4.8% | |
| india mark ii | 2400 | 4.0% | |
| afridev | 1770 | 3.0% | |
| ksb | 1415 | 2.4% | |
| other - rope pump | 451 | 0.8% | |
| Other values (8) | 701 | 1.2% |
| Max length | 25 |
|---|---|
| Mean length | 7.719511785 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
extraction_type_class
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| gravity | |
|---|---|
| handpump | |
| other | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| gravity | 26780 | 45.1% | |
| handpump | 16456 | 27.7% | |
| other | 6430 | 10.8% | |
| submersible | 6179 | 10.4% | |
| motorpump | 2987 | 5.0% | |
| rope pump | 451 | 0.8% | |
| wind-powered | 117 | 0.2% |
| Max length | 12 |
|---|---|
| Mean length | 7.602239057 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
extraction_type_group
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| gravity | |
|---|---|
| nira/tanira | |
| other | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| gravity | 26780 | 45.1% | |
| nira/tanira | 8154 | 13.7% | |
| other | 6430 | 10.8% | |
| submersible | 6179 | 10.4% | |
| swn 80 | 3670 | 6.2% | |
| mono | 2865 | 4.8% | |
| india mark ii | 2400 | 4.0% | |
| afridev | 1770 | 3.0% | |
| rope pump | 451 | 0.8% | |
| other handpump | 364 | 0.6% | |
| Other values (3) | 337 | 0.6% |
| Max length | 15 |
|---|---|
| Mean length | 7.880538721 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
funder
Categorical
| Distinct count | 1898 |
|---|---|
| Unique (%) | 3.2% |
| Missing (%) | 6.1% |
| Missing (n) | 3635 |
| Government Of Tanzania | |
|---|---|
| Danida | 3114 |
| Hesawa | 2202 |
| Other values (1894) | |
| (Missing) | 3635 |
| Value | Count | Frequency (%) | |
| Government Of Tanzania | 9084 | 15.3% | |
| Danida | 3114 | 5.2% | |
| Hesawa | 2202 | 3.7% | |
| Rwssp | 1374 | 2.3% | |
| World Bank | 1349 | 2.3% | |
| Kkkt | 1287 | 2.2% | |
| World Vision | 1246 | 2.1% | |
| Unicef | 1057 | 1.8% | |
| Tasaf | 877 | 1.5% | |
| District Council | 843 | 1.4% | |
| Other values (1887) | 33332 | 56.1% | |
| (Missing) | 3635 | 6.1% |
| Max length | 30 |
|---|---|
| Mean length | 9.505824916 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
gps_height
Numeric
| Distinct count | 2428 |
|---|---|
| Unique (%) | 4.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 668.2972391 |
|---|---|
| Minimum | -90 |
| Maximum | 2770 |
| Zeros (%) | 34.4% |
Quantile statistics
| Minimum | -90 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 369 |
| Q3 | 1319.25 |
| 95-th percentile | 1797 |
| Maximum | 2770 |
| Range | 2860 |
| Interquartile range | 1319.25 |
Descriptive statistics
| Standard deviation | 693.1163503 |
|---|---|
| Coef of variation | 1.037137833 |
| Kurtosis | -1.292440135 |
| Mean | 668.2972391 |
| MAD | 637.9529678 |
| Skewness | 0.462402085 |
| Sum | 39696856 |
| Variance | 480410.2751 |
| Memory size | 928.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ -90. -58. -50.5 -40.5 -28.5 ... 2180.5 2200.5 2366.5 2627.5 2770. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 20438 | 34.4% | |
| -15 | 60 | 0.1% | |
| -16 | 55 | 0.1% | |
| -13 | 55 | 0.1% | |
| -20 | 52 | 0.1% | |
| 1290 | 52 | 0.1% | |
| -14 | 51 | 0.1% | |
| 303 | 51 | 0.1% | |
| -18 | 49 | 0.1% | |
| -19 | 47 | 0.1% | |
| Other values (2418) | 38490 | 64.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -90 | 1 | < 0.1% | |
| -63 | 2 | < 0.1% | |
| -59 | 1 | < 0.1% | |
| -57 | 1 | < 0.1% | |
| -55 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2770 | 1 | < 0.1% | |
| 2628 | 1 | < 0.1% | |
| 2627 | 1 | < 0.1% | |
| 2626 | 2 | < 0.1% | |
| 2623 | 1 | < 0.1% |
id
Numeric
| Distinct count | 59400 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 37115.13177 |
|---|---|
| Minimum | 0 |
| Maximum | 74247 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3730.9 |
| Q1 | 18519.75 |
| Median | 37061.5 |
| Q3 | 55656.5 |
| 95-th percentile | 70564.05 |
| Maximum | 74247 |
| Range | 74247 |
| Interquartile range | 37136.75 |
Descriptive statistics
| Standard deviation | 21453.12837 |
|---|---|
| Coef of variation | 0.5780156866 |
| Kurtosis | -1.201515029 |
| Mean | 37115.13177 |
| MAD | 18586.04643 |
| Skewness | 0.00262253035 |
| Sum | 2204638827 |
| Variance | 460236716.9 |
| Memory size | 3.4 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 74247.], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 72310 | 1 | < 0.1% | |
| 49805 | 1 | < 0.1% | |
| 51852 | 1 | < 0.1% | |
| 62091 | 1 | < 0.1% | |
| 64138 | 1 | < 0.1% | |
| 57993 | 1 | < 0.1% | |
| 60040 | 1 | < 0.1% | |
| 33413 | 1 | < 0.1% | |
| 35460 | 1 | < 0.1% | |
| Other values (59390) | 59390 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 74247 | 1 | < 0.1% | |
| 74246 | 1 | < 0.1% | |
| 74243 | 1 | < 0.1% | |
| 74242 | 1 | < 0.1% | |
| 74240 | 1 | < 0.1% |
installer
Categorical
| Distinct count | 2146 |
|---|---|
| Unique (%) | 3.6% |
| Missing (%) | 6.2% |
| Missing (n) | 3655 |
| DWE | |
|---|---|
| Government | 1825 |
| RWE | 1206 |
| Other values (2142) | |
| (Missing) | 3655 |
| Value | Count | Frequency (%) | |
| DWE | 17402 | 29.3% | |
| Government | 1825 | 3.1% | |
| RWE | 1206 | 2.0% | |
| Commu | 1060 | 1.8% | |
| DANIDA | 1050 | 1.8% | |
| KKKT | 898 | 1.5% | |
| Hesawa | 840 | 1.4% | |
| 0 | 777 | 1.3% | |
| TCRS | 707 | 1.2% | |
| Central government | 622 | 1.0% | |
| Other values (2135) | 29358 | 49.4% | |
| (Missing) | 3655 | 6.2% |
| Max length | 30 |
|---|---|
| Mean length | 5.91976431 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
latitude
Numeric
| Distinct count | 57517 |
|---|---|
| Unique (%) | 96.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -5.70603266 |
|---|---|
| Minimum | -11.64944018 |
| Maximum | -2e-08 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -11.64944018 |
|---|---|
| 5-th percentile | -10.58554992 |
| Q1 | -8.540621305 |
| Median | -5.02159665 |
| Q3 | -3.32615564 |
| 95-th percentile | -1.408872227 |
| Maximum | -2e-08 |
| Range | 11.64944016 |
| Interquartile range | 5.214465665 |
Descriptive statistics
| Standard deviation | 2.946019081 |
|---|---|
| Coef of variation | -0.5162990219 |
| Kurtosis | -1.057616666 |
| Mean | -5.70603266 |
| MAD | 2.56776991 |
| Skewness | -0.1520365709 |
| Sum | -338938.34 |
| Variance | 8.679028427 |
| Memory size | 928.1 KiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[-1.16494402e+01 -1.15676907e+01 -1.14763553e+01 -1.14412923e+01 -1.13237074e+01 ... -1.19709397e+00 -1.14437511e+00 -9.98690175e-01 -4.99232185e-01 -2.00000000e-08], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -2e-08 | 1812 | 3.1% | |
| -6.99054864 | 2 | < 0.1% | |
| -2.48937845 | 2 | < 0.1% | |
| -2.51532072 | 2 | < 0.1% | |
| -6.96356538 | 2 | < 0.1% | |
| -2.5042939 | 2 | < 0.1% | |
| -9.2893492 | 2 | < 0.1% | |
| -2.51063865 | 2 | < 0.1% | |
| -6.99129411 | 2 | < 0.1% | |
| -2.48708461 | 2 | < 0.1% | |
| Other values (57507) | 57570 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -11.64944018 | 1 | < 0.1% | |
| -11.64837759 | 1 | < 0.1% | |
| -11.58629656 | 1 | < 0.1% | |
| -11.56857679 | 1 | < 0.1% | |
| -11.56680457 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -2e-08 | 1812 | 3.1% | |
| -0.99846435 | 1 | < 0.1% | |
| -0.998916 | 1 | < 0.1% | |
| -0.99901209 | 1 | < 0.1% | |
| -0.99911702 | 1 | < 0.1% |
lga
Categorical
| Distinct count | 125 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Njombe | 2503 |
|---|---|
| Arusha Rural | 1252 |
| Moshi Rural | 1251 |
| Other values (122) |
| Value | Count | Frequency (%) | |
| Njombe | 2503 | 4.2% | |
| Arusha Rural | 1252 | 2.1% | |
| Moshi Rural | 1251 | 2.1% | |
| Bariadi | 1177 | 2.0% | |
| Rungwe | 1106 | 1.9% | |
| Kilosa | 1094 | 1.8% | |
| Kasulu | 1047 | 1.8% | |
| Mbozi | 1034 | 1.7% | |
| Meru | 1009 | 1.7% | |
| Bagamoyo | 997 | 1.7% | |
| Other values (115) | 46930 | 79.0% |
| Max length | 16 |
|---|---|
| Mean length | 7.416885522 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
longitude
Numeric
| Distinct count | 57516 |
|---|---|
| Unique (%) | 96.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 34.07742669 |
|---|---|
| Minimum | 0 |
| Maximum | 40.34519307 |
| Zeros (%) | 3.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30.04066001 |
| Q1 | 33.09034738 |
| Median | 34.90874343 |
| Q3 | 37.17838657 |
| 95-th percentile | 39.13323954 |
| Maximum | 40.34519307 |
| Range | 40.34519307 |
| Interquartile range | 4.08803919 |
Descriptive statistics
| Standard deviation | 6.567431846 |
|---|---|
| Coef of variation | 0.1927208854 |
| Kurtosis | 19.18703105 |
| Mean | 34.07742669 |
| MAD | 3.302270448 |
| Skewness | -4.191046455 |
| Sum | 2024199.146 |
| Variance | 43.13116105 |
| Memory size | 3.4 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[ 0. 14.80356095 29.60716149 29.63885953 29.68126761 ... 39.67089348 39.88985935 40.10245293 40.20239876 40.34519307], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 1812 | 3.1% | |
| 39.08887513 | 2 | < 0.1% | |
| 39.10530661 | 2 | < 0.1% | |
| 37.54340145 | 2 | < 0.1% | |
| 38.18053774 | 2 | < 0.1% | |
| 32.98856004 | 2 | < 0.1% | |
| 32.99327684 | 2 | < 0.1% | |
| 39.09309544 | 2 | < 0.1% | |
| 39.10124424 | 2 | < 0.1% | |
| 32.96700926 | 2 | < 0.1% | |
| Other values (57506) | 57570 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1812 | 3.1% | |
| 29.6071219 | 1 | < 0.1% | |
| 29.60720109 | 1 | < 0.1% | |
| 29.61032056 | 1 | < 0.1% | |
| 29.61096482 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40.34519307 | 1 | < 0.1% | |
| 40.34430089 | 1 | < 0.1% | |
| 40.32523996 | 1 | < 0.1% | |
| 40.32522643 | 1 | < 0.1% | |
| 40.32340181 | 1 | < 0.1% |
management
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| vwc | |
|---|---|
| wug | 6515 |
| water board | 2933 |
| Other values (9) |
| Value | Count | Frequency (%) | |
| vwc | 40507 | 68.2% | |
| wug | 6515 | 11.0% | |
| water board | 2933 | 4.9% | |
| wua | 2535 | 4.3% | |
| private operator | 1971 | 3.3% | |
| parastatal | 1768 | 3.0% | |
| water authority | 904 | 1.5% | |
| other | 844 | 1.4% | |
| company | 685 | 1.2% | |
| unknown | 561 | 0.9% | |
| Other values (2) | 177 | 0.3% |
| Max length | 16 |
|---|---|
| Mean length | 4.350639731 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
management_group
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| user-group | |
|---|---|
| commercial | 3638 |
| parastatal | 1768 |
| Other values (2) | 1504 |
| Value | Count | Frequency (%) | |
| user-group | 52490 | 88.4% | |
| commercial | 3638 | 6.1% | |
| parastatal | 1768 | 3.0% | |
| other | 943 | 1.6% | |
| unknown | 561 | 0.9% |
| Max length | 10 |
|---|---|
| Mean length | 9.892289562 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
num_private
Numeric
| Distinct count | 65 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4741414141 |
|---|---|
| Minimum | 0 |
| Maximum | 1776 |
| Zeros (%) | 98.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1776 |
| Range | 1776 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 12.23622981 |
|---|---|
| Coef of variation | 25.80713147 |
| Kurtosis | 11137.29521 |
| Mean | 0.4741414141 |
| MAD | 0.9361978097 |
| Skewness | 91.93374999 |
| Sum | 28164 |
| Variance | 149.72532 |
| Memory size | 3.4 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 4.500e+00 5.500e+00 ... 9.800e+01 1.065e+02 1.550e+02 7.265e+02 1.776e+03], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 58643 | 98.7% | |
| 6 | 81 | 0.1% | |
| 1 | 73 | 0.1% | |
| 5 | 46 | 0.1% | |
| 8 | 46 | 0.1% | |
| 32 | 40 | 0.1% | |
| 45 | 36 | 0.1% | |
| 15 | 35 | 0.1% | |
| 39 | 30 | 0.1% | |
| 93 | 28 | < 0.1% | |
| Other values (55) | 342 | 0.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 58643 | 98.7% | |
| 1 | 73 | 0.1% | |
| 2 | 23 | < 0.1% | |
| 3 | 27 | < 0.1% | |
| 4 | 20 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1776 | 1 | < 0.1% | |
| 1402 | 1 | < 0.1% | |
| 755 | 1 | < 0.1% | |
| 698 | 1 | < 0.1% | |
| 672 | 1 | < 0.1% |
payment
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| never pay | |
|---|---|
| pay per bucket | |
| pay monthly | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| never pay | 25348 | 42.7% | |
| pay per bucket | 8985 | 15.1% | |
| pay monthly | 8300 | 14.0% | |
| unknown | 8157 | 13.7% | |
| pay when scheme fails | 3914 | 6.6% | |
| pay annually | 3642 | 6.1% | |
| other | 1054 | 1.8% |
| Max length | 21 |
|---|---|
| Mean length | 10.66479798 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
payment_type
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| never pay | |
|---|---|
| per bucket | |
| monthly | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| never pay | 25348 | 42.7% | |
| per bucket | 8985 | 15.1% | |
| monthly | 8300 | 14.0% | |
| unknown | 8157 | 13.7% | |
| on failure | 3914 | 6.6% | |
| annually | 3642 | 6.1% | |
| other | 1054 | 1.8% |
| Max length | 10 |
|---|---|
| Mean length | 8.530757576 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
permit
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 5.1% |
| Missing (n) | 3056 |
| True | |
|---|---|
| False | |
| (Missing) | 3056 |
| Value | Count | Frequency (%) | |
| True | 38852 | 65.4% | |
| False | 17492 | 29.4% | |
| (Missing) | 3056 | 5.1% |
population
Numeric
| Distinct count | 1049 |
|---|---|
| Unique (%) | 1.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 179.9099832 |
|---|---|
| Minimum | 0 |
| Maximum | 30500 |
| Zeros (%) | 36.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 25 |
| Q3 | 215 |
| 95-th percentile | 680 |
| Maximum | 30500 |
| Range | 30500 |
| Interquartile range | 215 |
Descriptive statistics
| Standard deviation | 471.4821757 |
|---|---|
| Coef of variation | 2.620655994 |
| Kurtosis | 402.2801153 |
| Mean | 179.9099832 |
| MAD | 214.6976938 |
| Skewness | 12.66071359 |
| Sum | 10686653 |
| Variance | 222295.442 |
| Memory size | 3.4 MiB |
Histogram with fixed size bins (bins=50)
Histogram with variable size bins (bins=[0.00000e+00 5.00000e-01 1.50000e+00 4.50000e+00 5.50000e+00 ... 5.00800e+03 6.88800e+03 6.96100e+03 1.07315e+04 3.05000e+04], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 21381 | 36.0% | |
| 1 | 7025 | 11.8% | |
| 200 | 1940 | 3.3% | |
| 150 | 1892 | 3.2% | |
| 250 | 1681 | 2.8% | |
| 300 | 1476 | 2.5% | |
| 100 | 1146 | 1.9% | |
| 50 | 1139 | 1.9% | |
| 500 | 1009 | 1.7% | |
| 350 | 986 | 1.7% | |
| Other values (1039) | 19725 | 33.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 21381 | 36.0% | |
| 1 | 7025 | 11.8% | |
| 2 | 4 | < 0.1% | |
| 3 | 4 | < 0.1% | |
| 4 | 13 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 30500 | 1 | < 0.1% | |
| 15300 | 1 | < 0.1% | |
| 11463 | 1 | < 0.1% | |
| 10000 | 3 | < 0.1% | |
| 9865 | 1 | < 0.1% |
public_meeting
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 5.6% |
| Missing (n) | 3334 |
| True | |
|---|---|
| False | 5055 |
| (Missing) | 3334 |
| Value | Count | Frequency (%) | |
| True | 51011 | 85.9% | |
| False | 5055 | 8.5% | |
| (Missing) | 3334 | 5.6% |
quality_group
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| good | |
|---|---|
| salty | 5195 |
| unknown | 1876 |
| Other values (3) | 1511 |
| Value | Count | Frequency (%) | |
| good | 50818 | 85.6% | |
| salty | 5195 | 8.7% | |
| unknown | 1876 | 3.2% | |
| milky | 804 | 1.4% | |
| colored | 490 | 0.8% | |
| fluoride | 217 | 0.4% |
| Max length | 8 |
|---|---|
| Mean length | 4.23510101 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
quantity
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| enough | |
|---|---|
| insufficient | |
| dry | 6246 |
| Other values (2) | 4839 |
| Value | Count | Frequency (%) | |
| enough | 33186 | 55.9% | |
| insufficient | 15129 | 25.5% | |
| dry | 6246 | 10.5% | |
| seasonal | 4050 | 6.8% | |
| unknown | 789 | 1.3% |
| Max length | 12 |
|---|---|
| Mean length | 7.362373737 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
quantity_group
Recoded
This variable is a recoding of quantity and should be ignored for analysis
recorded_by
Constant
This variable is constant and should be ignored for analysis
| Constant value | GeoData Consultants Ltd |
|---|
region
Categorical
| Distinct count | 21 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Iringa | 5294 |
|---|---|
| Shinyanga | 4982 |
| Mbeya | 4639 |
| Other values (18) |
| Value | Count | Frequency (%) | |
| Iringa | 5294 | 8.9% | |
| Shinyanga | 4982 | 8.4% | |
| Mbeya | 4639 | 7.8% | |
| Kilimanjaro | 4379 | 7.4% | |
| Morogoro | 4006 | 6.7% | |
| Arusha | 3350 | 5.6% | |
| Kagera | 3316 | 5.6% | |
| Mwanza | 3102 | 5.2% | |
| Kigoma | 2816 | 4.7% | |
| Ruvuma | 2640 | 4.4% | |
| Other values (11) | 20876 | 35.1% |
| Max length | 13 |
|---|---|
| Mean length | 6.623754209 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
region_code
Numeric
| Distinct count | 27 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 15.29700337 |
|---|---|
| Minimum | 1 |
| Maximum | 99 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| Median | 12 |
| Q3 | 17 |
| 95-th percentile | 60 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range | 12 |
Descriptive statistics
| Standard deviation | 17.58740634 |
|---|---|
| Coef of variation | 1.149728866 |
| Kurtosis | 10.28843341 |
| Mean | 15.29700337 |
| MAD | 9.486968586 |
| Skewness | 3.17381811 |
| Sum | 908642 |
| Variance | 309.3168617 |
| Memory size | 3.4 MiB |
Histogram with fixed size bins (bins=27)
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 32. 50. 70. 85. 99. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 11 | 5300 | 8.9% | |
| 17 | 5011 | 8.4% | |
| 12 | 4639 | 7.8% | |
| 3 | 4379 | 7.4% | |
| 5 | 4040 | 6.8% | |
| 18 | 3324 | 5.6% | |
| 19 | 3047 | 5.1% | |
| 2 | 3024 | 5.1% | |
| 16 | 2816 | 4.7% | |
| 10 | 2640 | 4.4% | |
| Other values (17) | 21180 | 35.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 2201 | 3.7% | |
| 2 | 3024 | 5.1% | |
| 3 | 4379 | 7.4% | |
| 4 | 2513 | 4.2% | |
| 5 | 4040 | 6.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 99 | 423 | 0.7% | |
| 90 | 917 | 1.5% | |
| 80 | 1238 | 2.1% | |
| 60 | 1025 | 1.7% | |
| 40 | 1 | < 0.1% |
scheme_management
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 6.5% |
| Missing (n) | 3877 |
| VWC | |
|---|---|
| WUG | 5206 |
| Water authority | 3153 |
| Other values (9) | |
| (Missing) | 3877 |
| Value | Count | Frequency (%) | |
| VWC | 36793 | 61.9% | |
| WUG | 5206 | 8.8% | |
| Water authority | 3153 | 5.3% | |
| WUA | 2883 | 4.9% | |
| Water Board | 2748 | 4.6% | |
| Parastatal | 1680 | 2.8% | |
| Private operator | 1063 | 1.8% | |
| Company | 1061 | 1.8% | |
| Other | 766 | 1.3% | |
| SWC | 97 | 0.2% | |
| Other values (2) | 73 | 0.1% | |
| (Missing) | 3877 | 6.5% |
| Max length | 16 |
|---|---|
| Mean length | 4.537373737 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
scheme_name
Categorical
| Distinct count | 2697 |
|---|---|
| Unique (%) | 4.5% |
| Missing (%) | 47.4% |
| Missing (n) | 28166 |
| K | 682 |
|---|---|
| None | 644 |
| Borehole | 546 |
| Other values (2693) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| K | 682 | 1.1% | |
| None | 644 | 1.1% | |
| Borehole | 546 | 0.9% | |
| Chalinze wate | 405 | 0.7% | |
| M | 400 | 0.7% | |
| DANIDA | 379 | 0.6% | |
| Government | 320 | 0.5% | |
| Ngana water supplied scheme | 270 | 0.5% | |
| wanging'ombe water supply s | 261 | 0.4% | |
| wanging'ombe supply scheme | 234 | 0.4% | |
| Other values (2686) | 27093 | 45.6% | |
| (Missing) | 28166 | 47.4% |
| Max length | 46 |
|---|---|
| Mean length | 8.94456229 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
source
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| spring | |
|---|---|
| shallow well | |
| machine dbh | |
| Other values (7) |
| Value | Count | Frequency (%) | |
| spring | 17021 | 28.7% | |
| shallow well | 16824 | 28.3% | |
| machine dbh | 11075 | 18.6% | |
| river | 9612 | 16.2% | |
| rainwater harvesting | 2295 | 3.9% | |
| hand dtw | 874 | 1.5% | |
| lake | 765 | 1.3% | |
| dam | 656 | 1.1% | |
| other | 212 | 0.4% | |
| unknown | 66 | 0.1% |
| Max length | 20 |
|---|---|
| Mean length | 8.978804714 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
source_class
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| groundwater | |
|---|---|
| surface | |
| unknown | 278 |
| Value | Count | Frequency (%) | |
| groundwater | 45794 | 77.1% | |
| surface | 13328 | 22.4% | |
| unknown | 278 | 0.5% |
| Max length | 11 |
|---|---|
| Mean length | 10.08377104 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
source_type
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| spring | |
|---|---|
| shallow well | |
| borehole | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| spring | 17021 | 28.7% | |
| shallow well | 16824 | 28.3% | |
| borehole | 11949 | 20.1% | |
| river/lake | 10377 | 17.5% | |
| rainwater harvesting | 2295 | 3.9% | |
| dam | 656 | 1.1% | |
| other | 278 | 0.5% |
| Max length | 20 |
|---|---|
| Mean length | 9.303602694 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
status_group
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| functional | |
|---|---|
| non functional | |
| functional needs repair | 4317 |
| Value | Count | Frequency (%) | |
| functional | 32259 | 54.3% | |
| non functional | 22824 | 38.4% | |
| functional needs repair | 4317 | 7.3% |
| Max length | 23 |
|---|---|
| Mean length | 12.48176768 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
subvillage
Categorical
| Distinct count | 19288 |
|---|---|
| Unique (%) | 32.5% |
| Missing (%) | 0.6% |
| Missing (n) | 371 |
| Madukani | 508 |
|---|---|
| Shuleni | 506 |
| Majengo | 502 |
| Other values (19284) |
| Value | Count | Frequency (%) | |
| Madukani | 508 | 0.9% | |
| Shuleni | 506 | 0.9% | |
| Majengo | 502 | 0.8% | |
| Kati | 373 | 0.6% | |
| Mtakuja | 262 | 0.4% | |
| Sokoni | 232 | 0.4% | |
| M | 187 | 0.3% | |
| Muungano | 172 | 0.3% | |
| Mbuyuni | 164 | 0.3% | |
| Mlimani | 152 | 0.3% | |
| Other values (19277) | 55971 | 94.2% | |
| (Missing) | 371 | 0.6% |
| Max length | 30 |
|---|---|
| Mean length | 7.867003367 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
ward
Categorical
| Distinct count | 2092 |
|---|---|
| Unique (%) | 3.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Igosi | 307 |
|---|---|
| Imalinyi | 252 |
| Siha Kati | 232 |
| Other values (2089) |
| Value | Count | Frequency (%) | |
| Igosi | 307 | 0.5% | |
| Imalinyi | 252 | 0.4% | |
| Siha Kati | 232 | 0.4% | |
| Mdandu | 231 | 0.4% | |
| Nduruma | 217 | 0.4% | |
| Mishamo | 203 | 0.3% | |
| Kitunda | 203 | 0.3% | |
| Msindo | 201 | 0.3% | |
| Chalinze | 196 | 0.3% | |
| Maji ya Chai | 190 | 0.3% | |
| Other values (2082) | 57168 | 96.2% |
| Max length | 23 |
|---|---|
| Mean length | 7.505841751 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
water_quality
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| soft | |
|---|---|
| salty | 4856 |
| unknown | 1876 |
| Other values (5) | 1850 |
| Value | Count | Frequency (%) | |
| soft | 50818 | 85.6% | |
| salty | 4856 | 8.2% | |
| unknown | 1876 | 3.2% | |
| milky | 804 | 1.4% | |
| coloured | 490 | 0.8% | |
| salty abandoned | 339 | 0.6% | |
| fluoride | 200 | 0.3% | |
| fluoride abandoned | 17 | < 0.1% |
| Max length | 18 |
|---|---|
| Mean length | 4.303282828 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
waterpoint_type
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| communal standpipe | |
|---|---|
| hand pump | |
| other | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| communal standpipe | 28522 | 48.0% | |
| hand pump | 17488 | 29.4% | |
| other | 6380 | 10.7% | |
| communal standpipe multiple | 6103 | 10.3% | |
| improved spring | 784 | 1.3% | |
| cattle trough | 116 | 0.2% | |
| dam | 7 | < 0.1% |
| Max length | 27 |
|---|---|
| Mean length | 14.82757576 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
waterpoint_type_group
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| communal standpipe | |
|---|---|
| hand pump | |
| other | 6380 |
| Other values (3) | 907 |
| Value | Count | Frequency (%) | |
| communal standpipe | 34625 | 58.3% | |
| hand pump | 17488 | 29.4% | |
| other | 6380 | 10.7% | |
| improved spring | 784 | 1.3% | |
| cattle trough | 116 | 0.2% | |
| dam | 7 | < 0.1% |
| Max length | 18 |
|---|---|
| Mean length | 13.90287879 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
wpt_name
Categorical
| Distinct count | 37400 |
|---|---|
| Unique (%) | 63.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| none | 3563 |
|---|---|
| Shuleni | 1748 |
| Zahanati | 830 |
| Other values (37397) |
| Value | Count | Frequency (%) | |
| none | 3563 | 6.0% | |
| Shuleni | 1748 | 2.9% | |
| Zahanati | 830 | 1.4% | |
| Msikitini | 535 | 0.9% | |
| Kanisani | 323 | 0.5% | |
| Bombani | 271 | 0.5% | |
| Sokoni | 260 | 0.4% | |
| Ofisini | 254 | 0.4% | |
| School | 208 | 0.4% | |
| Shule Ya Msingi | 199 | 0.3% | |
| Other values (37390) | 51209 | 86.2% |
| Max length | 30 |
|---|---|
| Mean length | 10.96210438 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
First rows
| amount_tsh | basin | construction_year | date_recorded | district_code | extraction_type | extraction_type_class | extraction_type_group | funder | gps_height | id | installer | latitude | lga | longitude | management | management_group | num_private | payment | payment_type | permit | population | public_meeting | quality_group | quantity | quantity_group | recorded_by | region | region_code | scheme_management | scheme_name | source | source_class | source_type | status_group | subvillage | ward | water_quality | waterpoint_type | waterpoint_type_group | wpt_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 6000.0 | Lake Nyasa | 1999 | 2011-03-14 | 5 | gravity | gravity | gravity | Roman | 1390 | 69572 | Roman | -9.856322 | Ludewa | 34.938093 | vwc | user-group | 0 | pay annually | annually | False | 109 | True | good | enough | enough | GeoData Consultants Ltd | Iringa | 11 | VWC | Roman | spring | groundwater | spring | functional | Mnyusi B | Mundindi | soft | communal standpipe | communal standpipe | none |
| 1 | 0.0 | Lake Victoria | 2010 | 2013-03-06 | 2 | gravity | gravity | gravity | Grumeti | 1399 | 8776 | GRUMETI | -2.147466 | Serengeti | 34.698766 | wug | user-group | 0 | never pay | never pay | True | 280 | NaN | good | insufficient | insufficient | GeoData Consultants Ltd | Mara | 20 | Other | NaN | rainwater harvesting | surface | rainwater harvesting | functional | Nyamara | Natta | soft | communal standpipe | communal standpipe | Zahanati |
| 2 | 25.0 | Pangani | 2009 | 2013-02-25 | 4 | gravity | gravity | gravity | Lottery Club | 686 | 34310 | World vision | -3.821329 | Simanjiro | 37.460664 | vwc | user-group | 0 | pay per bucket | per bucket | True | 250 | True | good | enough | enough | GeoData Consultants Ltd | Manyara | 21 | VWC | Nyumba ya mungu pipe scheme | dam | surface | dam | functional | Majengo | Ngorika | soft | communal standpipe multiple | communal standpipe | Kwa Mahundi |
| 3 | 0.0 | Ruvuma / Southern Coast | 1986 | 2013-01-28 | 63 | submersible | submersible | submersible | Unicef | 263 | 67743 | UNICEF | -11.155298 | Nanyumbu | 38.486161 | vwc | user-group | 0 | never pay | never pay | True | 58 | True | good | dry | dry | GeoData Consultants Ltd | Mtwara | 90 | VWC | NaN | machine dbh | groundwater | borehole | non functional | Mahakamani | Nanyumbu | soft | communal standpipe multiple | communal standpipe | Zahanati Ya Nanyumbu |
| 4 | 0.0 | Lake Victoria | 0 | 2011-07-13 | 1 | gravity | gravity | gravity | Action In A | 0 | 19728 | Artisan | -1.825359 | Karagwe | 31.130847 | other | other | 0 | never pay | never pay | True | 0 | True | good | seasonal | seasonal | GeoData Consultants Ltd | Kagera | 18 | NaN | NaN | rainwater harvesting | surface | rainwater harvesting | functional | Kyanyamisa | Nyakasimbi | soft | communal standpipe | communal standpipe | Shuleni |
| 5 | 20.0 | Pangani | 2009 | 2011-03-13 | 8 | submersible | submersible | submersible | Mkinga Distric Coun | 0 | 9944 | DWE | -4.765587 | Mkinga | 39.172796 | vwc | user-group | 0 | pay per bucket | per bucket | True | 1 | True | salty | enough | enough | GeoData Consultants Ltd | Tanga | 4 | VWC | Zingibali | other | unknown | other | functional | Moa/Mwereme | Moa | salty | communal standpipe multiple | communal standpipe | Tajiri |
| 6 | 0.0 | Internal | 0 | 2012-10-01 | 3 | swn 80 | handpump | swn 80 | Dwsp | 0 | 19816 | DWSP | -3.766365 | Shinyanga Rural | 33.362410 | vwc | user-group | 0 | never pay | never pay | True | 0 | True | good | enough | enough | GeoData Consultants Ltd | Shinyanga | 17 | VWC | NaN | machine dbh | groundwater | borehole | non functional | Ishinabulandi | Samuye | soft | hand pump | hand pump | Kwa Ngomho |
| 7 | 0.0 | Lake Tanganyika | 0 | 2012-10-09 | 3 | nira/tanira | handpump | nira/tanira | Rwssp | 0 | 54551 | DWE | -4.226198 | Kahama | 32.620617 | wug | user-group | 0 | unknown | unknown | True | 0 | True | milky | enough | enough | GeoData Consultants Ltd | Shinyanga | 17 | NaN | NaN | shallow well | groundwater | shallow well | non functional | Nyawishi Center | Chambo | milky | hand pump | hand pump | Tushirikiane |
| 8 | 0.0 | Lake Tanganyika | 0 | 2012-11-03 | 6 | india mark ii | handpump | india mark ii | Wateraid | 0 | 53934 | Water Aid | -5.146712 | Tabora Urban | 32.711100 | vwc | user-group | 0 | never pay | never pay | True | 0 | True | salty | seasonal | seasonal | GeoData Consultants Ltd | Tabora | 14 | VWC | NaN | machine dbh | groundwater | borehole | non functional | Imalauduki | Itetemia | salty | hand pump | hand pump | Kwa Ramadhan Musa |
| 9 | 0.0 | Lake Victoria | 0 | 2011-08-03 | 1 | nira/tanira | handpump | nira/tanira | Isingiro Ho | 0 | 46144 | Artisan | -1.257051 | Karagwe | 30.626991 | vwc | user-group | 0 | never pay | never pay | True | 0 | True | good | enough | enough | GeoData Consultants Ltd | Kagera | 18 | NaN | NaN | shallow well | groundwater | shallow well | functional | Mkonomre | Kaisho | soft | hand pump | hand pump | Kwapeto |
Last rows
| amount_tsh | basin | construction_year | date_recorded | district_code | extraction_type | extraction_type_class | extraction_type_group | funder | gps_height | id | installer | latitude | lga | longitude | management | management_group | num_private | payment | payment_type | permit | population | public_meeting | quality_group | quantity | quantity_group | recorded_by | region | region_code | scheme_management | scheme_name | source | source_class | source_type | status_group | subvillage | ward | water_quality | waterpoint_type | waterpoint_type_group | wpt_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59390 | 0.0 | Lake Tanganyika | 1991 | 2011-08-04 | 2 | swn 80 | handpump | swn 80 | Rudep | 1715 | 13677 | DWE | -8.258160 | Sumbawanga Rural | 31.370848 | vwc | user-group | 0 | never pay | never pay | False | 150 | True | good | insufficient | insufficient | GeoData Consultants Ltd | Rukwa | 15 | VWC | NaN | machine dbh | groundwater | borehole | functional | Kitonto | Mkowe | soft | hand pump | hand pump | Kwa Mzee Atanas |
| 59391 | 0.0 | Pangani | 1967 | 2013-08-03 | 3 | gravity | gravity | gravity | Government Of Tanzania | 540 | 44885 | Government | -4.272218 | Same | 38.044070 | vwc | user-group | 0 | never pay | never pay | True | 210 | True | good | enough | enough | GeoData Consultants Ltd | Kilimanjaro | 3 | Water authority | Hingilili | river | surface | river/lake | non functional | Maore Kati | Maore | soft | communal standpipe | communal standpipe | Kwa |
| 59392 | 0.0 | Lake Rukwa | 0 | 2011-04-15 | 1 | gravity | gravity | gravity | Government Of Tanzania | 0 | 40607 | Government | -8.520888 | Chunya | 33.009440 | vwc | user-group | 0 | never pay | never pay | True | 0 | True | good | enough | enough | GeoData Consultants Ltd | Mbeya | 12 | VWC | NaN | spring | groundwater | spring | non functional | Mbuyuni A | Mbuyuni | soft | communal standpipe | communal standpipe | Benard Charles |
| 59393 | 0.0 | Internal | 0 | 2012-10-27 | 2 | gravity | gravity | gravity | Private | 0 | 48348 | Private | -4.287410 | Igunga | 33.866852 | private operator | commercial | 0 | pay per bucket | per bucket | False | 0 | False | good | insufficient | insufficient | GeoData Consultants Ltd | Tabora | 14 | Water authority | NaN | dam | surface | dam | functional | Masanga | Igunga | soft | other | other | Kwa Peter |
| 59394 | 500.0 | Wami / Ruvu | 2007 | 2011-03-09 | 6 | submersible | submersible | submersible | World Bank | 351 | 11164 | ML appro | -6.124830 | Mvomero | 37.634053 | vwc | user-group | 0 | pay monthly | monthly | True | 89 | True | good | enough | enough | GeoData Consultants Ltd | Morogoro | 5 | VWC | NaN | machine dbh | groundwater | borehole | non functional | Komstari | Diongoya | soft | communal standpipe | communal standpipe | Chimeredya |
| 59395 | 10.0 | Pangani | 1999 | 2013-05-03 | 5 | gravity | gravity | gravity | Germany Republi | 1210 | 60739 | CES | -3.253847 | Hai | 37.169807 | water board | user-group | 0 | pay per bucket | per bucket | True | 125 | True | good | enough | enough | GeoData Consultants Ltd | Kilimanjaro | 3 | Water Board | Losaa Kia water supply | spring | groundwater | spring | functional | Kiduruni | Masama Magharibi | soft | communal standpipe | communal standpipe | Area Three Namba 27 |
| 59396 | 4700.0 | Rufiji | 1996 | 2011-05-07 | 4 | gravity | gravity | gravity | Cefa-njombe | 1212 | 27263 | Cefa | -9.070629 | Njombe | 35.249991 | vwc | user-group | 0 | pay annually | annually | True | 56 | True | good | enough | enough | GeoData Consultants Ltd | Iringa | 11 | VWC | Ikondo electrical water sch | river | surface | river/lake | functional | Igumbilo | Ikondo | soft | communal standpipe | communal standpipe | Kwa Yahona Kuvala |
| 59397 | 0.0 | Rufiji | 0 | 2011-04-11 | 7 | swn 80 | handpump | swn 80 | NaN | 0 | 37057 | NaN | -8.750434 | Mbarali | 34.017087 | vwc | user-group | 0 | pay monthly | monthly | False | 0 | True | fluoride | enough | enough | GeoData Consultants Ltd | Mbeya | 12 | VWC | NaN | machine dbh | groundwater | borehole | functional | Madungulu | Chimala | fluoride | hand pump | hand pump | Mashine |
| 59398 | 0.0 | Rufiji | 0 | 2011-03-08 | 4 | nira/tanira | handpump | nira/tanira | Malec | 0 | 31282 | Musa | -6.378573 | Chamwino | 35.861315 | vwc | user-group | 0 | never pay | never pay | True | 0 | True | good | insufficient | insufficient | GeoData Consultants Ltd | Dodoma | 1 | VWC | NaN | shallow well | groundwater | shallow well | functional | Mwinyi | Mvumi Makulu | soft | hand pump | hand pump | Mshoro |
| 59399 | 0.0 | Wami / Ruvu | 2002 | 2011-03-23 | 2 | nira/tanira | handpump | nira/tanira | World Bank | 191 | 26348 | World | -6.747464 | Morogoro Rural | 38.104048 | vwc | user-group | 0 | pay when scheme fails | on failure | True | 150 | True | salty | enough | enough | GeoData Consultants Ltd | Morogoro | 5 | VWC | NaN | shallow well | groundwater | shallow well | functional | Kikatanyemba | Ngerengere | salty | hand pump | hand pump | Kwa Mzee Lugawa |